Problem Note 60056: The SAS® Deployment Backup and Recovery Tool might report that the database for a solution data server was recovered successfully when it was not
 |  |  |  |
Problem
When you use the Deployment Backup and Recovery Tool batch command sas-recover-offline, recovery of a SAS® solution data server might be incorrectly reported as successful. In this scenario, the tool reports success even if it was unable to connect to the data server to perform a recovery.
When this problem occurs, sas-recover-offline reports the recovery for the sourceType DATABASE as successful. Here is an example:
status: SUCCES
backupSources
sourceType: DATABASE
status: SUCCESS
But, when you examine the SAS-configuration-directory\Levn\Backup\backupserver.log file, you find a message that says the connection to the database for the restore was refused. Here is an example:
INFO com.sas.svcs.backup.server.handler.PostgresRecoveryHandler - pg_restore: [archiver (db)] connection to database "databaseName" failed: could not connect to server: Connection refused (0x0000274D/10061)
INFO com.sas.svcs.backup.server.handler.PostgresRecoveryHandler - Is the server running on host yourhost.yourdomain.com (your IP address) and accepting TCP/IP connections on port 5432?
Cause
This problem might occur if you did not start the solution data server before executing sas-recover-offline. If the solution data server is not running, then the Deployment Backup and Recovery Tool is not able to connect to the solution data server. However, the tool does not report this as a failure for the database recovery.
Solution
A fix for this issue is planned for a future release of SAS software.
If you encounter this problem, stop all servers and services except the SAS® Metadata Server, SAS® Web Infrastructure Platform Data Server (including any solution data servers), and the SAS® Deployment Agent. Then, run sas-recover-offline a second time.
To read about the steps for performing a recovery using the Deployment Backup and Recovery Tool, see the SAS Intelligence Platform Batch Tools: Reference of the SAS® 9.4 Intelligence Platform: System Administration Guide, Fourth Edition.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Deployment Backup and Recovery Tool | Solaris for x64 | 9.42 | 9.44 | 9.4 TS1M4 | 9.4 TS1M6 |
| Linux for x64 | 9.42 | 9.44 | 9.4 TS1M4 | 9.4 TS1M6 | ||
| HP-UX IPF | 9.42 | 9.44 | 9.4 TS1M4 | 9.4 TS1M6 | ||
| 64-bit Enabled Solaris | 9.42 | 9.44 | 9.4 TS1M4 | 9.4 TS1M6 | ||
| 64-bit Enabled AIX | 9.42 | 9.44 | 9.4 TS1M4 | 9.4 TS1M6 | ||
| Microsoft® Windows® for x64 | 9.42 | 9.44 | 9.4 TS1M4 | 9.4 TS1M6 | ||
| z/OS | 9.42 | 9.44 | 9.4 TS1M4 | 9.4 TS1M6 | ||